AL Synchronize Databases

Flexible, bidirectional, and asynchronous synchronization between Business Central and external databases.

Ensure your Business Central data is always consistent with external databases with AL Synchronize Databases - a powerful all-in-one solution that connects your Business Central suite to virtually any external database.

Overview

Keeping Business Central data aligned with external databases can be challenging. Manual procedures are error-prone, and most tools only allow synchronization with a single database type.

AL Synchronize Databases provides a reliable solution by offering:

• Bidirectional synchronization between Business Central and external databases.
• Asynchronous operation, so data changes are never lost even if the connection goes down.
• Support for multiple database types, currently Microsoft SQL Server and PostgreSQL, with an extensible architecture to add more.
• Flexible configuration for nodes, interfaces, and groups of nodes with different schedules.

Key Benefits

• Synchronize all your databases, including Business Central and external systems.
• Ensure data consistency across platforms.
• Operates bidirectionally and asynchronously.
• Save time with optimized synchronization, processing only modified, inserted, or deleted records.
• Automatic table creation on external databases, optimized with indexes and triggers for synchronization flags.
• Support for master-detail relationships, enabling complex parent-child data structures.
• Field-level management: choose which fields to synchronize, validate, or rename.
• Event hooks: implement custom logic on row import for flexible workflows.
• Scalability: run multiple synchronization processes in parallel, each with its own schedule.
• Simplified setup: in Business Central, simply provide the table number; the system automatically lists the fields for configuration.
• Robust error handling: the system always moves from one consistent state to another; failed imports remain for reprocessing or debugging.

How It Works

1. Synchronization Nodes and Interfaces - Each interface is managed through a node connected to a specific external database.
2. Customizable Synchronization - Define which fields to sync, whether to apply validation triggers, or rename fields to match the external database.
3. Performance Optimization - Only records that changed are synchronized, using synchronization flags.
4. Automated External Table Creation - The system can generate tables in the external database optimized for synchronization.
5. Master-Detail Support - Synchronize linked parent-child interfaces seamlessly.
6. Event Hooks - Trigger custom business logic when importing rows.
7. Parallel Processing - Multiple processes can run concurrently for maximum efficiency.

Supported Databases

• Microsoft SQL Server
• PostgreSQL
• Extensible: additional database types can be added by implementing a simple interface.

About Dynamics App Lab

Dynamics App Lab is the main distributor of Microsoft 365 Business Central solutions for Applibra. With decades of experience in software development, we deliver apps that gather the best functions and features to enhance company efficiency.